![]() |
![]() |
![]() |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
To access the contents, click the chapter and section titles.
Oracle Performance Tuning and Optimization
Appendix C
|
Analyze the Problem | This step involves understanding what the issues are, if any. You may determine that there is no problem. |
Determine the Cause | Look into what is causing the problem you are experiencing. It is not always obvious. |
Determine a Solution | In this step, you determine a course of action and set expectations. It may be that you expect that your solution wont fix the problem, but determining the solution always provides you with valuable information. |
Test the Solution | In this step, you test your assumptions and try a fix. |
Analyze the Result | In this step, you determine the success or failure of your solution. It may be that a failure to fix the problem is the expected result but that it provides good information about the cause of the problem. |
Figure C.1 The problem-solving methodology flowchart.
The flowchart in Figure C.2 represents the user-transaction profile presented in Chapter 24, What Is a Well-Tuned Statement?
Figure C.2 The user-transaction profile.
The flowchart in Figure C.3 is the same flowchart presented in Chapter 24. It shows the steps taken to process SQL statements.
Figure C.3 SQL statement processing flowchart.
The flowchart in Figure C.4 represents the workings of the Oracle optimizer as described in Chapter 27, Using the Oracle Optimizer.
Figure C.4 The Oracle optimizer.
Table of Contents |
![]() |
Products | Contact Us | About Us | Privacy | Ad Info | Home
Use of this site is subject to certain Terms & Conditions, Copyright © 1996-2000 EarthWeb Inc. All rights reserved. Reproduction whole or in part in any form or medium without express written permission of EarthWeb is prohibited. Read EarthWeb's privacy statement. |